Create the Column Charts Part 1 9
Create the Column Charts
Step 8.1 – Create the Race Chart
Insert the line and clustered column chart visualization.
Make the visualization bigger.
Add the measures .Total Shootings and .Total Victims to the Column
Values.
Add the measure .Average YOY SHO to the line values.
For the measures .Total Shootings and .Total Victims choose the option show value as percent of the grand total.
Rename the fields.
In the Format tab select the following options:
Change the measurement format from general to percentage.
Sort the visualization by Total Shootings % descending.
Step 8.2 – Race Tooltip
Insert a new page with the following configuration:
This Tooltip is made up of 2 types of visualizations: 2 maps and 4 cards.
Start by inserting a map visualization and adding the following
fields:
On the format tab input the following options.
After all these configurations the map should look like this:
Add the filed State to the filters and select all except for
Hawaii.
Change the format to the City, Latitude and Longitude columns.
Copy the visualization and paste it. Change the size and the coordinates.
In the State filter, select only Hawaii and unselect the rest of
the states.
Change the title to Hawaii and the font size to 8pts.
The Tooltip should look like this at this point.
Create the following measure:
.Victims Per Shooting = DIVIDE([.Total Victims], [.Total
Shootings])+0
Insert one card visualization.
Add the .Victims Per Shooting measure to this visualization.
Configure it according to the following pictures:
After these changes, the card should look like this:
For the next card, copy paste the card Victims Per Shooting and
change the measure, title, and coordinates.
The title is Victims.
The measure is .Total Victims.
The coordinates are:
For the 3rd card, repeat the steps taken to create the
2nd one.
The title is Shootings.
The measure is .Total Shootings.
The coordinates are:
At this point the visualization should look like this.
Copy and paste the 3rd visualization and make the
following changes:
Select the field Shooters_Race for this visualization.
Turn off the title
Turn on the background and select the blue color.
Select white as the color for the data label.
The coordinates for the position
are X=0, Y=300.
Go back to the Dashboard.
Select the Race chart.
Activate the tooltip option.
Select the page Race TP.
https://www.pluralsight.com/guides/bar-and-column-charts-in-power-bi